﻿<cfscript>
DB = 'chinalaohu';
dbt = 'auction';
domain = 'http://192.168.6.104';
</cfscript>


<!---<cfloop from="1201" to="1300" index="i">

<cfquery datasource="#DB#">
INSERT INTO `auction` 
VALUES (#i#, 91, '131183', 8, 1, 4, 0, 1, '苹果测试#i#', #i#, NULL, '<br>', '', 1.00, 0.00, 0.00, 10.00, '2013-9-4 00:00:00', '2013-9-4 00:00:00', '2013-9-30 00:00:00', NULL, 0, 0, 0, '2013-9-9 19:25:21', '2013-9-9 19:31:57', 0, '0', '手绘彩瓷', '粉盒', '', '', '');
</cfquery>

<cfquery datasource="#DB#">
insert into auction_gallery(agid,aid,img_url,img_waterfall)
values(#i#,#i#,'/upload/img/620x316/23.png','/upload/waterfall/180x180.png')
</cfquery>
</cfloop>--->

<cfloop from="1001" to="1300" index="i">
<cfscript>
iw =  '/upload/100' & i & '.png';
</cfscript>
<cfquery datasource="#DB#">
update auction_gallery set
img_waterfall ='#iw#'
where agid = #i#

</cfquery>

</cfloop>